package com.cloudlead.commonData.query;

import static com.mysema.query.types.PathMetadataFactory.*;
import com.cloudlead.commonData.entity.ETbContainerInfo;


import com.mysema.query.types.path.*;

import com.mysema.query.types.PathMetadata;
import javax.annotation.Generated;
import com.mysema.query.types.Path;

import com.mysema.query.sql.ColumnMetadata;
import java.sql.Types;

import com.mysema.query.sql.*;

import com.cloudlead.common.lang.annotation.Label;


/**
 * QTbContainerInfo is a Querydsl query type for ETbContainerInfo
 */
@Label("TbContainerInfo查询")
@Generated("com.cloudlead.utils.persistence.codegen.serializer.SimpleMetaDataSerializer")
public class QTbContainerInfo extends RelationalPathBase<ETbContainerInfo> {

    private static final long serialVersionUID = -90796744;

    public static final QTbContainerInfo tbContainerInfo = new QTbContainerInfo("tb_container_info");

    public class PrimaryKeys {

        public final PrimaryKey<ETbContainerInfo> primary = createPrimaryKey(id);

    }

    public class ForeignKeys {

        public final ForeignKey<com.cloudlead.commonData.entity.ETbCustomerOrder> customerFk = createForeignKey(tbCustomerOrderId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseCar> trailerCarIdFk = createForeignKey(trailerCarId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseCar> carFk = createForeignKey(carId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbFleetOrder> fleetOrderFk = createForeignKey(fleetOrderId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseDriver> driverFk = createForeignKey(driverId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseDriver> trailerDriverIdFk = createForeignKey(trailerDriverId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbProgress> _tbProgressTbContainerInfo1Fk = createInvForeignKey(id, "tb_container_info_id");

    }

    public final StringPath carId = createString("carId");

    public final StringPath carNumber = createString("carNumber");

    public final NumberPath<Double> carPrice = createNumber("carPrice", Double.class);

    public final StringPath comments = createString("comments");

    public final DateTimePath<org.joda.time.DateTime> confirmTime = createDateTime("confirmTime", org.joda.time.DateTime.class);

    public final StringPath contactPerson = createString("contactPerson");

    public final StringPath contactTel = createString("contactTel");

    public final StringPath containerNo = createString("containerNo");

    public final StringPath containerSeal = createString("containerSeal");

    public final NumberPath<Float> containerWeight = createNumber("containerWeight", Float.class);

    public final DateTimePath<org.joda.time.DateTime> createDate = createDateTime("createDate", org.joda.time.DateTime.class);

    public final StringPath dangerous = createString("dangerous");

    public final StringPath driverId = createString("driverId");

    public final StringPath feedBack = createString("feedBack");

    public final DateTimePath<org.joda.time.DateTime> finishTime = createDateTime("finishTime", org.joda.time.DateTime.class);

    public final StringPath flag = createString("flag");

    public final StringPath fleetOrderId = createString("fleetOrderId");

    public final StringPath fleetStatus = createString("fleetStatus");

    public final NumberPath<Double> forwarderPrice = createNumber("forwarderPrice", Double.class);

    public final StringPath id = createString("id");

    public final DateTimePath<org.joda.time.DateTime> intoTime = createDateTime("intoTime", org.joda.time.DateTime.class);

    public final StringPath isStart = createString("isStart");

    public final StringPath minato = createString("minato");

    public final DateTimePath<org.joda.time.DateTime> outTime = createDateTime("outTime", org.joda.time.DateTime.class);

    public final DateTimePath<org.joda.time.DateTime> planDate = createDateTime("planDate", org.joda.time.DateTime.class);

    public final DateTimePath<org.joda.time.DateTime> saveDate = createDateTime("saveDate", org.joda.time.DateTime.class);

    public final StringPath sendCarPepole = createString("sendCarPepole");

    public final DateTimePath<org.joda.time.DateTime> sendCarTime = createDateTime("sendCarTime", org.joda.time.DateTime.class);

    public final StringPath serialNumber = createString("serialNumber");

    public final StringPath shipStatus = createString("shipStatus");

    public final DateTimePath<org.joda.time.DateTime> suitcaseTime = createDateTime("suitcaseTime", org.joda.time.DateTime.class);

    public final StringPath tbCustomerOrderId = createString("tbCustomerOrderId");

    public final StringPath temp = createString("temp");

    public final StringPath trailerCarId = createString("trailerCarId");

    public final StringPath trailerDriverId = createString("trailerDriverId");

    public final StringPath trailerFlag = createString("trailerFlag");

    public final StringPath type = createString("type");

    public final NumberPath<Float> volume = createNumber("volume", Float.class);

    public final PrimaryKeys pk = new PrimaryKeys();

    public final ForeignKeys fk = new ForeignKeys();

    public QTbContainerInfo(String variable) {
        super(ETbContainerInfo.class, forVariable(variable), "null", "tb_container_info");
        addMetadata();
    }

    public QTbContainerInfo(String variable, String schema, String table) {
        super(ETbContainerInfo.class, forVariable(variable), schema, table);
        addMetadata();
    }

    public QTbContainerInfo(Path<? extends ETbContainerInfo> path) {
        super(path.getType(), path.getMetadata(), "null", "tb_container_info");
        addMetadata();
    }

    public QTbContainerInfo(PathMetadata<?> metadata) {
        super(ETbContainerInfo.class, metadata, "null", "tb_container_info");
        addMetadata();
    }

    public void addMetadata() {
        addMetadata(carId, ColumnMetadata.named("carId").withIndex(10).ofType(Types.CHAR).withSize(24));
        addMetadata(carNumber, ColumnMetadata.named("carNumber").withIndex(22).ofType(Types.VARCHAR).withSize(45));
        addMetadata(carPrice, ColumnMetadata.named("carPrice").withIndex(37).ofType(Types.DOUBLE).withSize(22));
        addMetadata(comments, ColumnMetadata.named("comments").withIndex(4).ofType(Types.VARCHAR).withSize(1000));
        addMetadata(confirmTime, ColumnMetadata.named("confirmTime").withIndex(35).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(contactPerson, ColumnMetadata.named("contactPerson").withIndex(17).ofType(Types.VARCHAR).withSize(45));
        addMetadata(contactTel, ColumnMetadata.named("contactTel").withIndex(18).ofType(Types.VARCHAR).withSize(45));
        addMetadata(containerNo, ColumnMetadata.named("containerNo").withIndex(12).ofType(Types.VARCHAR).withSize(45));
        addMetadata(containerSeal, ColumnMetadata.named("containerSeal").withIndex(11).ofType(Types.VARCHAR).withSize(45));
        addMetadata(containerWeight, ColumnMetadata.named("containerWeight").withIndex(2).ofType(Types.REAL).withSize(12));
        addMetadata(createDate, ColumnMetadata.named("createDate").withIndex(36).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(dangerous, ColumnMetadata.named("dangerous").withIndex(21).ofType(Types.VARCHAR).withSize(45));
        addMetadata(driverId, ColumnMetadata.named("driverId").withIndex(25).ofType(Types.CHAR).withSize(24));
        addMetadata(feedBack, ColumnMetadata.named("feedBack").withIndex(33).ofType(Types.VARCHAR).withSize(1000));
        addMetadata(finishTime, ColumnMetadata.named("finishTime").withIndex(31).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(flag, ColumnMetadata.named("flag").withIndex(6).ofType(Types.VARCHAR).withSize(8));
        addMetadata(fleetOrderId, ColumnMetadata.named("fleet_order_id").withIndex(24).ofType(Types.CHAR).withSize(24));
        addMetadata(fleetStatus, ColumnMetadata.named("fleetStatus").withIndex(13).ofType(Types.VARCHAR).withSize(45));
        addMetadata(forwarderPrice, ColumnMetadata.named("forwarderPrice").withIndex(38).ofType(Types.DOUBLE).withSize(22));
        addMetadata(id, ColumnMetadata.named("id").withIndex(1).ofType(Types.CHAR).withSize(24).notNull());
        addMetadata(intoTime, ColumnMetadata.named("intoTime").withIndex(29).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(isStart, ColumnMetadata.named("isStart").withIndex(34).ofType(Types.VARCHAR).withSize(8));
        addMetadata(minato, ColumnMetadata.named("minato").withIndex(19).ofType(Types.VARCHAR).withSize(45));
        addMetadata(outTime, ColumnMetadata.named("outTime").withIndex(30).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(planDate, ColumnMetadata.named("planDate").withIndex(3).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(saveDate, ColumnMetadata.named("saveDate").withIndex(8).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(sendCarPepole, ColumnMetadata.named("sendCarPepole").withIndex(16).ofType(Types.VARCHAR).withSize(45));
        addMetadata(sendCarTime, ColumnMetadata.named("sendCarTime").withIndex(32).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(serialNumber, ColumnMetadata.named("serialNumber").withIndex(15).ofType(Types.VARCHAR).withSize(255));
        addMetadata(shipStatus, ColumnMetadata.named("shipStatus").withIndex(14).ofType(Types.VARCHAR).withSize(45));
        addMetadata(suitcaseTime, ColumnMetadata.named("suitcaseTime").withIndex(28).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(tbCustomerOrderId, ColumnMetadata.named("tb_customer_order_id").withIndex(5).ofType(Types.CHAR).withSize(24));
        addMetadata(temp, ColumnMetadata.named("temp").withIndex(20).ofType(Types.VARCHAR).withSize(45));
        addMetadata(trailerCarId, ColumnMetadata.named("trailerCarId").withIndex(26).ofType(Types.CHAR).withSize(24));
        addMetadata(trailerDriverId, ColumnMetadata.named("trailerDriverId").withIndex(27).ofType(Types.CHAR).withSize(24));
        addMetadata(trailerFlag, ColumnMetadata.named("trailerFlag").withIndex(23).ofType(Types.VARCHAR).withSize(45));
        addMetadata(type, ColumnMetadata.named("type").withIndex(9).ofType(Types.VARCHAR).withSize(8));
        addMetadata(volume, ColumnMetadata.named("volume").withIndex(7).ofType(Types.REAL).withSize(12));
    }

}

